Dataset info
| Number of variables | 62 |
|---|---|
| Number of observations | 90697 |
| Missing cells | 832241 (14.8%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 160.5 MiB |
| Average record size in memory | 1.8 KiB |
Variables types
| CAT | 36 |
|---|---|
| NUM | 17 |
| BOOL | 8 |
| DATE | 1 |
Reproduction info
| Date of analysis | 2020-05-18 12:32:59.147027 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
Alternative_purchasing_group has 3542 (3.9%) missing values | Missing |
Alternative_purchasing_group has a high cardinality: 561 distinct values | Warning |
ATC has a high cardinality: 1111 distinct values | Warning |
Chemical_/_biological has 7621 (8.4%) missing values | Missing |
consumption has 7514 (8.3%) zeros | Zeros |
consumption_previous_year has 3745 (4.1%) zeros | Zeros |
Current_consumption has 8480 (9.3%) zeros | Zeros |
Dangerous_material_is_charged_with_a_permit has 80310 (88.5%) missing values | Missing |
dangerous_substance has 80326 (88.6%) missing values | Missing |
Date_of_basket_entry has 41213 (45.4%) missing values | Missing |
Date_of_basket_entry has a high cardinality: 54 distinct values | Warning |
Description_Alternative_purchasing_group has 3542 (3.9%) missing values | Missing |
Description_Alternative_purchasing_group has a high cardinality: 561 distinct values | Warning |
Description_outline has 6891 (7.6%) missing values | Missing |
Description_outline has a high cardinality: 306 distinct values | Warning |
European_patent_expires has 89409 (98.6%) missing values | Missing |
For_adults has 86837 (95.7%) missing values | Missing |
Form_of_giving has 52945 (58.4%) missing values | Missing |
GENERY_FATHER has 53724 (59.2%) missing values | Missing |
GENERY_FATHER has a high cardinality: 680 distinct values | Warning |
Inventory has 10370 (11.4%) zeros | Zeros |
Inventory_of_consumption_months is highly skewed (γ1 = 82.270332) | Skewed |
Inventory_of_consumption_months has 32934 (36.3%) zeros | Zeros |
Main_outline has 6891 (7.6%) missing values | Missing |
Main_outline has a high cardinality: 306 distinct values | Warning |
Narcotic_/_psychotropic has 41313 (45.6%) missing values | Missing |
Narcotic_/_psychotropic has 46358 (51.1%) zeros | Zeros |
Plant has constant value "7350.0" | Rejected |
Prediction has 8934 (9.9%) zeros | Zeros |
PRICE is highly skewed (γ1 = 24.55626018) | Skewed |
Price_for_absolute_packaging has 1324 (1.5%) zeros | Zeros |
Quantity_in_absolute_packaging has 1324 (1.5%) zeros | Zeros |
Quantity_in_Packaging-Absolute has 1324 (1.5%) zeros | Zeros |
Quantity_in_packing-relative has 64712 (71.3%) zeros | Zeros |
Safety_Stock has 9502 (10.5%) zeros | Zeros |
Send_code_to_Omri has constant value "1.0" | Rejected |
Serving_form has 7904 (8.7%) missing values | Missing |
Serving_form has a high cardinality: 53 distinct values | Warning |
skucode2 has a high cardinality: 3207 distinct values | Warning |
status has constant value "1.0" | Rejected |
Toxic_item has 7362 (8.1%) missing values | Missing |
type_of_packeging has 85285 (94.0%) missing values | Missing |
U#S#_Patent_Expires has 89166 (98.3%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has 86155 (95.0%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values | Warning |
VENDOR has a high cardinality: 155 distinct values | Warning |
consumption_previous_year is highly correlated with consumption and 2 other fields | High Correlation |
consumption is highly correlated with consumption_previous_year and 2 other fields | High Correlation |
Current_consumption is highly correlated with consumption and 2 other fields | High Correlation |
General_purpose_ is highly correlated with General_purpose | High Correlation |
General_purpose is highly correlated with General_purpose_ | High Correlation |
Prediction is highly correlated with consumption and 2 other fields | High Correlation |
Quantity_in_Packaging-Absolute is highly correlated with Quantity_in_absolute_packaging | High Correlation |
Quantity_in_absolute_packaging is highly correlated with Quantity_in_Packaging-Absolute | High Correlation |
Safety_Stock is highly correlated with Inventory | High Correlation |
Inventory is highly correlated with Safety_Stock | High Correlation |
General_purpose_ is highly correlated with General_purpose | High Correlation |
General_purpose is highly correlated with General_purpose_ | High Correlation |
month_year_ is highly correlated with month_year | High Correlation |
month_year is highly correlated with month_year_ | High Correlation |
A_group_of_materials
Real number (ℝ≥0)
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19380.69801 |
|---|---|
| Minimum | 1000 |
| Maximum | 20400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 10170 |
| Q1 | 20120 |
| median | 20160 |
| Q3 | 20190 |
| 95-th percentile | 20271 |
| Maximum | 20400 |
| Range | 19400 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 2749.296447 |
|---|---|
| Coefficient of variation (CV) | 0.1418574525 |
| Kurtosis | 9.513002339 |
| Mean | 19380.69801 |
| Median Absolute Deviation (MAD) | 1456.125489 |
| Skewness | -3.294453069 |
| Sum | 1757771167 |
| Variance | 7558630.951 |
| Value | Count | Frequency (%) | |
| 20190 | 14723 | 16.2% | |
| 20100 | 11235 | 12.4% | |
| 20120 | 9449 | 10.4% | |
| 20130 | 7744 | 8.5% | |
| 20210 | 5920 | 6.5% | |
| 20140 | 5192 | 5.7% | |
| 20270 | 4324 | 4.8% | |
| 20220 | 3800 | 4.2% | |
| 20180 | 3707 | 4.1% | |
| 20110 | 3031 | 3.3% | |
| Other values (28) | 21572 | 23.8% |
| Value | Count | Frequency (%) | |
| 1000 | 112 | 0.1% | |
| 2000 | 2 | < 0.1% | |
| 8000 | 243 | 0.3% | |
| 10100 | 739 | 0.8% | |
| 10120 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20400 | 75 | 0.1% | |
| 20276 | 799 | 0.9% | |
| 20275 | 9 | < 0.1% | |
| 20274 | 75 | 0.1% | |
| 20273 | 1389 | 1.5% |
ABC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| C | |
|---|---|
| B | |
| A |
| Value | Count | Frequency (%) | |
| C | 49485 | 54.6% | |
| B | 30334 | 33.4% | |
| A | 10878 | 12.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
Affiliation_Group
Categorical
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 147 |
| Missing (%) | 0.2% |
| Memory size | 708.6 KiB |
| 20 | |
|---|---|
| 11 | |
| 13 | |
| 24 | |
| 14 | |
| Other values (33) |
| Value | Count | Frequency (%) | |
| 20 | 14504 | 16.0% | |
| 11 | 11556 | 12.7% | |
| 13 | 9668 | 10.7% | |
| 24 | 9137 | 10.1% | |
| 14 | 8010 | 8.8% | |
| 21 | 6052 | 6.7% | |
| 15 | 5254 | 5.8% | |
| 22 | 4072 | 4.5% | |
| 19 | 3955 | 4.4% | |
| 17 | 2889 | 3.2% | |
| Other values (28) | 15453 | 17.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.003241563 |
| Min length | 2 |
| Distinct count | 561 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3542 |
| Missing (%) | 3.9% |
| Memory size | 708.6 KiB |
| 1734 | 2963 |
|---|---|
| 1591 | 1889 |
| 1875 | 1705 |
| 1068 | 1515 |
| 1823 | 1352 |
| Other values (555) |
| Value | Count | Frequency (%) | |
| 1734 | 2963 | 3.3% | |
| 1591 | 1889 | 2.1% | |
| 1875 | 1705 | 1.9% | |
| 1068 | 1515 | 1.7% | |
| 1823 | 1352 | 1.5% | |
| 1317 | 1309 | 1.4% | |
| 1053 | 1217 | 1.3% | |
| 1642 | 1027 | 1.1% | |
| 1027 | 965 | 1.1% | |
| 1354 | 952 | 1.0% | |
| Other values (550) | 72261 | 79.7% | |
| (Missing) | 3542 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1111 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1/0/1900 | 6714 |
|---|---|
| ATC: | 1096 |
| ATC:M01AE01 | 887 |
| ATC:C10AA07 | 631 |
| ATC:C10AA05 | 622 |
| Other values (1106) |
| Value | Count | Frequency (%) | |
| 1/0/1900 | 6714 | 7.4% | |
| ATC: | 1096 | 1.2% | |
| ATC:M01AE01 | 887 | 1.0% | |
| ATC:C10AA07 | 631 | 0.7% | |
| ATC:C10AA05 | 622 | 0.7% | |
| ATC:N03AX16 | 618 | 0.7% | |
| ATC:A11AA06 | 611 | 0.7% | |
| ATC:N06BA04 | 587 | 0.6% | |
| ATC:A11CC05 | 545 | 0.6% | |
| ATC:A07FA01 | 531 | 0.6% | |
| Other values (1101) | 77855 | 85.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 10.53277396 |
| Min length | 4 |
Basic_unit_of_measure
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| EA | |
|---|---|
| PAC | 14365 |
| KIT | 321 |
| BLS | 24 |
| BT | 22 |
| Value | Count | Frequency (%) | |
| EA | 75965 | 83.8% | |
| PAC | 14365 | 15.8% | |
| KIT | 321 | 0.4% | |
| BLS | 24 | < 0.1% | |
| BT | 22 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.162188386 |
| Min length | 2 |
Budget_Group
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| B | |
|---|---|
| E | |
| A | |
| D | 5580 |
| H | 102 |
| Value | Count | Frequency (%) | |
| B | 43242 | 47.7% | |
| E | 23065 | 25.4% | |
| A | 18708 | 20.6% | |
| D | 5580 | 6.2% | |
| H | 102 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7621 |
| Missing (%) | 8.4% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 2 | 2981 |
| Value | Count | Frequency (%) | |
| 1 | 80095 | 88.3% | |
| 2 | 2981 | 3.3% | |
| (Missing) | 7621 | 8.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
chronic
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 428 |
| Missing (%) | 0.5% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | |
| (Missing) | 428 |
| Value | Count | Frequency (%) | |
| 0 | 51192 | 56.4% | |
| 1 | 39077 | 43.1% | |
| (Missing) | 428 | 0.5% |
Consumer_management
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 708.6 KiB |
| ave | |
|---|---|
| pred |
| Value | Count | Frequency (%) | |
| ave | 74914 | 82.6% | |
| pred | 15782 | 17.4% | |
| (Missing) | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.174018986 |
| Min length | 3 |
| Distinct count | 2224 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78024.95626 |
|---|---|
| Minimum | 0 |
| Maximum | 4392300 |
| Zeros | 7514 |
| Zeros (%) | 8.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 828 |
| median | 4703 |
| Q3 | 47350 |
| 95-th percentile | 376105 |
| Maximum | 4392300 |
| Range | 4392300 |
| Interquartile range (IQR) | 46522 |
Descriptive statistics
| Standard deviation | 245380.8128 |
|---|---|
| Coefficient of variation (CV) | 3.144901638 |
| Kurtosis | 107.022945 |
| Mean | 78024.95626 |
| Median Absolute Deviation (MAD) | 108086.0629 |
| Skewness | 8.428340271 |
| Sum | 7076629458 |
| Variance | 6.021174328e+10 |
| Value | Count | Frequency (%) | |
| 0 | 7514 | 8.3% | |
| 1025 | 133 | 0.1% | |
| 1097 | 126 | 0.1% | |
| 384 | 121 | 0.1% | |
| 27290 | 120 | 0.1% | |
| 2427 | 118 | 0.1% | |
| 5688 | 117 | 0.1% | |
| 678 | 116 | 0.1% | |
| 136200 | 113 | 0.1% | |
| 1177 | 110 | 0.1% | |
| Other values (2214) | 82109 | 90.5% |
| Value | Count | Frequency (%) | |
| 0 | 7514 | 8.3% | |
| 1 | 25 | < 0.1% | |
| 2 | 20 | < 0.1% | |
| 3 | 16 | < 0.1% | |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4392300 | 60 | 0.1% | |
| 3318000 | 60 | 0.1% | |
| 3239610 | 60 | 0.1% | |
| 1633120 | 60 | 0.1% | |
| 1590350 | 60 | 0.1% |
| Distinct count | 2755 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 887840.7473 |
|---|---|
| Minimum | 0.0 |
| Maximum | 46044870.0 |
| Zeros | 3745 |
| Zeros (%) | 4.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 735.4 |
| Q1 | 11172 |
| median | 62310 |
| Q3 | 598950 |
| 95-th percentile | 4533600 |
| Maximum | 46044870 |
| Range | 46044870 |
| Interquartile range (IQR) | 587778 |
Descriptive statistics
| Standard deviation | 2701115.98 |
|---|---|
| Coefficient of variation (CV) | 3.042342885 |
| Kurtosis | 98.28656155 |
| Mean | 887840.7473 |
| Median Absolute Deviation (MAD) | 1208727.411 |
| Skewness | 8.102139676 |
| Sum | 8.052449226e+10 |
| Variance | 7.296027539e+12 |
| Value | Count | Frequency (%) | |
| 0 | 3745 | 4.1% | |
| 12687 | 106 | 0.1% | |
| 9622 | 94 | 0.1% | |
| 11371 | 87 | 0.1% | |
| 5770 | 83 | 0.1% | |
| 17716 | 83 | 0.1% | |
| 4532 | 79 | 0.1% | |
| 454770 | 79 | 0.1% | |
| 3530 | 70 | 0.1% | |
| 8341 | 62 | 0.1% | |
| Other values (2745) | 86209 | 95.1% |
| Value | Count | Frequency (%) | |
| 0 | 3745 | 4.1% | |
| 1 | 59 | 0.1% | |
| 3 | 3 | < 0.1% | |
| 10 | 50 | 0.1% | |
| 13 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 46044870 | 60 | 0.1% | |
| 37611900 | 60 | 0.1% | |
| 35771040 | 60 | 0.1% | |
| 19037280 | 60 | 0.1% | |
| 16971570 | 60 | 0.1% |
| Distinct count | 2212 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103993.5932 |
|---|---|
| Minimum | 0 |
| Maximum | 5666490 |
| Zeros | 8480 |
| Zeros (%) | 9.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 969 |
| median | 5850 |
| Q3 | 62790 |
| 95-th percentile | 520530 |
| Maximum | 5666490 |
| Range | 5666490 |
| Interquartile range (IQR) | 61821 |
Descriptive statistics
| Standard deviation | 322385.0218 |
|---|---|
| Coefficient of variation (CV) | 3.100046955 |
| Kurtosis | 101.3871974 |
| Mean | 103993.5932 |
| Median Absolute Deviation (MAD) | 144213.3013 |
| Skewness | 8.168678076 |
| Sum | 9431906920 |
| Variance | 1.039321023e+11 |
| Value | Count | Frequency (%) | |
| 0 | 8480 | 9.3% | |
| 3355 | 154 | 0.2% | |
| 120 | 151 | 0.2% | |
| 1023 | 147 | 0.2% | |
| 602 | 142 | 0.2% | |
| 180 | 137 | 0.2% | |
| 763 | 129 | 0.1% | |
| 722 | 119 | 0.1% | |
| 3814 | 118 | 0.1% | |
| 1401 | 117 | 0.1% | |
| Other values (2202) | 81003 | 89.3% |
| Value | Count | Frequency (%) | |
| 0 | 8480 | 9.3% | |
| 1 | 1 | < 0.1% | |
| 2 | 77 | 0.1% | |
| 3 | 26 | < 0.1% | |
| 4 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5666490 | 60 | 0.1% | |
| 4368000 | 60 | 0.1% | |
| 4218780 | 60 | 0.1% | |
| 2010420 | 60 | 0.1% | |
| 1938600 | 60 | 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80310 |
| Missing (%) | 88.5% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 329 |
| Value | Count | Frequency (%) | |
| 0 | 10058 | 11.1% | |
| 1 | 329 | 0.4% | |
| (Missing) | 80310 | 88.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.656427445 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 80326 |
| Missing (%) | 88.6% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 644 |
| Value | Count | Frequency (%) | |
| 0 | 9727 | 10.7% | |
| 1 | 644 | 0.7% | |
| (Missing) | 80326 | 88.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.65695668 |
| Min length | 1 |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 41213 |
| Missing (%) | 45.4% |
| Memory size | 708.6 KiB |
| 01.01.1995 | |
|---|---|
| 01.01.2000 | 4298 |
| 01.03.2001 | 3333 |
| 01.03.1999 | 2760 |
| 01.03.2002 | 2118 |
| Other values (48) |
| Value | Count | Frequency (%) | |
| 01.01.1995 | 23781 | 26.2% | |
| 01.01.2000 | 4298 | 4.7% | |
| 01.03.2001 | 3333 | 3.7% | |
| 01.03.1999 | 2760 | 3.0% | |
| 01.03.2002 | 2118 | 2.3% | |
| 01.01.2009 | 1418 | 1.6% | |
| 01.05.2006 | 1402 | 1.5% | |
| 01.03.2008 | 1070 | 1.2% | |
| 15.01.2015 | 853 | 0.9% | |
| 01.01.2010 | 790 | 0.9% | |
| Other values (43) | 7661 | 8.4% | |
| (Missing) | 41213 | 45.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.273581265 |
| Min length | 4 |
| Distinct count | 561 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 3542 |
| Missing (%) | 3.9% |
| Memory size | 708.6 KiB |
| Hypertension | 2963 |
|---|---|
| Bact.Inf., Sys. | 1889 |
| Statines | 1705 |
| EPILEPSY- Anticonvulsants | 1515 |
| Pain, Mod/Sev | 1352 |
| Other values (555) |
| Value | Count | Frequency (%) | |
| Hypertension | 2963 | 3.3% | |
| Bact.Inf., Sys. | 1889 | 2.1% | |
| Statines | 1705 | 1.9% | |
| EPILEPSY- Anticonvulsants | 1515 | 1.7% | |
| Pain, Mod/Sev | 1352 | 1.5% | |
| הורדת חום ושיכוך כאב | 1309 | 1.4% | |
| Depression-SSRI | 1217 | 1.3% | |
| Diabetes Mell. | 1027 | 1.1% | |
| BPH | 965 | 1.1% | |
| טיפול אנטי פטרייתי | 952 | 1.0% | |
| Other values (550) | 72261 | 79.7% | |
| (Missing) | 3542 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 15.21452749 |
| Min length | 2 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6891 |
| Missing (%) | 7.6% |
| Memory size | 708.6 KiB |
| Hypertension | 3180 |
|---|---|
| Diabetes Mell. | 3005 |
| food adittive | 2471 |
| Not Designated | 2361 |
| Epilepsy | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| Hypertension | 3180 | 3.5% | |
| Diabetes Mell. | 3005 | 3.3% | |
| food adittive | 2471 | 2.7% | |
| Not Designated | 2361 | 2.6% | |
| Epilepsy | 2016 | 2.2% | |
| Bact.Inf., Sys. | 1893 | 2.1% | |
| cosmetics | 1868 | 2.1% | |
| Statines | 1705 | 1.9% | |
| Antidepressants | 1683 | 1.9% | |
| Pain, Mild/Mod. | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.4% | |
| (Missing) | 6891 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 12.00066154 |
| Min length | 3 |
| Distinct count | 90697 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54602.10858 |
|---|---|
| Minimum | 0 |
| Maximum | 109199 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5442.8 |
| Q1 | 27270 |
| median | 54644 |
| Q3 | 81884 |
| 95-th percentile | 103723.2 |
| Maximum | 109199 |
| Range | 109199 |
| Interquartile range (IQR) | 54614 |
Descriptive statistics
| Standard deviation | 31526.67024 |
|---|---|
| Coefficient of variation (CV) | 0.5773892449 |
| Kurtosis | -1.200406177 |
| Mean | 54602.10858 |
| Median Absolute Deviation (MAD) | 27307.16505 |
| Skewness | -0.001034537182 |
| Sum | 4952247442 |
| Variance | 993930936.5 |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 101028 | 1 | < 0.1% | |
| 60104 | 1 | < 0.1% | |
| 58057 | 1 | < 0.1% | |
| 64202 | 1 | < 0.1% | |
| 62155 | 1 | < 0.1% | |
| 49869 | 1 | < 0.1% | |
| 56014 | 1 | < 0.1% | |
| 8913 | 1 | < 0.1% | |
| 15058 | 1 | < 0.1% | |
| Other values (90687) | 90687 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 109199 | 1 | < 0.1% | |
| 109198 | 1 | < 0.1% | |
| 109197 | 1 | < 0.1% | |
| 109196 | 1 | < 0.1% | |
| 109195 | 1 | < 0.1% |
| Distinct count | 879 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| Minimum | 2006-03-06 00:00:00 |
|---|---|
| Maximum | 2019-08-19 00:00:00 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 89409 |
| Missing (%) | 98.6% |
| Memory size | 708.6 KiB |
| 01.02.2015 | |
|---|---|
| 01.06.2017 | 99 |
| 01.03.2016 | 98 |
| 01.10.2018 | 96 |
| 01.03.2017 | 81 |
| Other values (24) |
| Value | Count | Frequency (%) | |
| 01.02.2015 | 168 | 0.2% | |
| 01.06.2017 | 99 | 0.1% | |
| 01.03.2016 | 98 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.09.2019 | 65 | 0.1% | |
| 01.12.2022 | 61 | 0.1% | |
| 01.05.2020 | 60 | 0.1% | |
| 01.07.2018 | 59 | 0.1% | |
| 01.05.2019 | 53 | 0.1% | |
| Other values (19) | 448 | 0.5% | |
| (Missing) | 89409 | 98.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.085206787 |
| Min length | 4 |
Exceptional_policy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 9680 |
| Value | Count | Frequency (%) | |
| 0 | 81017 | 89.3% | |
| 1 | 9680 | 10.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 86837 |
| Missing (%) | 95.7% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 3860 | 4.3% | |
| (Missing) | 86837 | 95.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.872322128 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 52945 |
| Missing (%) | 58.4% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 17 | 22 |
| 15 | 6 |
| Value | Count | Frequency (%) | |
| 0 | 37724 | 41.6% | |
| 17 | 22 | < 0.1% | |
| 15 | 6 | < 0.1% | |
| (Missing) | 52945 | 58.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.751579435 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89272 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 6 | 842 |
| 2 | 378 |
| 1 | 205 |
| Value | Count | Frequency (%) | |
| 0 | 89272 | 98.4% | |
| 6 | 842 | 0.9% | |
| 2 | 378 | 0.4% | |
| 1 | 205 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 680 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 53724 |
| Missing (%) | 59.2% |
| Memory size | 708.6 KiB |
| 3999001541 | 186 |
|---|---|
| 3999001291 | 179 |
| 3999019172 | 178 |
| 3999001511 | 177 |
| 3999001491 | 176 |
| Other values (674) |
| Value | Count | Frequency (%) | |
| 3999001541 | 186 | 0.2% | |
| 3999001291 | 179 | 0.2% | |
| 3999019172 | 178 | 0.2% | |
| 3999001511 | 177 | 0.2% | |
| 3999001491 | 176 | 0.2% | |
| 3999001490 | 174 | 0.2% | |
| 3999001150 | 171 | 0.2% | |
| 3999001542 | 171 | 0.2% | |
| 3999003522 | 167 | 0.2% | |
| 3999001280 | 165 | 0.2% | |
| Other values (669) | 35229 | 38.8% | |
| (Missing) | 53724 | 59.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.445924341 |
| Min length | 4 |
| Distinct count | 2253 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104031.0092 |
|---|---|
| Minimum | 0 |
| Maximum | 6462780 |
| Zeros | 10370 |
| Zeros (%) | 11.4% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1251 |
| median | 5710 |
| Q3 | 65750 |
| 95-th percentile | 488730 |
| Maximum | 6462780 |
| Range | 6462780 |
| Interquartile range (IQR) | 64499 |
Descriptive statistics
| Standard deviation | 362225.5124 |
|---|---|
| Coefficient of variation (CV) | 3.481899438 |
| Kurtosis | 134.4122878 |
| Mean | 104031.0092 |
| Median Absolute Deviation (MAD) | 144642.8975 |
| Skewness | 9.625140566 |
| Sum | 9435300440 |
| Variance | 1.312073218e+11 |
| Value | Count | Frequency (%) | |
| 0 | 10370 | 11.4% | |
| 875 | 130 | 0.1% | |
| 7306 | 120 | 0.1% | |
| 5258 | 120 | 0.1% | |
| 400 | 120 | 0.1% | |
| 6647 | 120 | 0.1% | |
| 2208 | 117 | 0.1% | |
| 41412 | 116 | 0.1% | |
| 74370 | 115 | 0.1% | |
| 2547 | 114 | 0.1% | |
| Other values (2243) | 79255 | 87.4% |
| Value | Count | Frequency (%) | |
| 0 | 10370 | 11.4% | |
| 2 | 8 | < 0.1% | |
| 5 | 59 | 0.1% | |
| 6 | 32 | < 0.1% | |
| 7 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6462780 | 60 | 0.1% | |
| 6338010 | 60 | 0.1% | |
| 3606000 | 60 | 0.1% | |
| 2664180 | 60 | 0.1% | |
| 2465100 | 60 | 0.1% |
| Distinct count | 32 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.324707543 |
|---|---|
| Minimum | 0 |
| Maximum | 786 |
| Zeros | 32934 |
| Zeros (%) | 36.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 786 |
| Range | 786 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 7.409864836 |
|---|---|
| Coefficient of variation (CV) | 5.593585449 |
| Kurtosis | 8391.898955 |
| Mean | 1.324707543 |
| Median Absolute Deviation (MAD) | 1.183926836 |
| Skewness | 82.270332 |
| Sum | 120147 |
| Variance | 54.90609688 |
| Value | Count | Frequency (%) | |
| 0 | 32934 | 36.3% | |
| 1 | 30986 | 34.2% | |
| 2 | 16412 | 18.1% | |
| 3 | 6882 | 7.6% | |
| 4 | 1739 | 1.9% | |
| 5 | 626 | 0.7% | |
| 6 | 244 | 0.3% | |
| 7 | 157 | 0.2% | |
| 8 | 121 | 0.1% | |
| 10 | 104 | 0.1% | |
| Other values (22) | 492 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 32934 | 36.3% | |
| 1 | 30986 | 34.2% | |
| 2 | 16412 | 18.1% | |
| 3 | 6882 | 7.6% | |
| 4 | 1739 | 1.9% |
| Value | Count | Frequency (%) | |
| 786 | 6 | < 0.1% | |
| 255 | 2 | < 0.1% | |
| 145 | 18 | < 0.1% | |
| 109 | 15 | < 0.1% | |
| 98 | 21 | < 0.1% |
Item_in_health_basket
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 155 |
| Missing (%) | 0.2% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 155 |
| Value | Count | Frequency (%) | |
| 1 | 56296 | 62.1% | |
| 0 | 34246 | 37.8% | |
| (Missing) | 155 | 0.2% |
Item_Type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 405 |
| Missing (%) | 0.4% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 252 |
| 6 | 60 |
| 3 | 60 |
| Value | Count | Frequency (%) | |
| 0 | 89920 | 99.1% | |
| 1 | 252 | 0.3% | |
| 6 | 60 | 0.1% | |
| 3 | 60 | 0.1% | |
| (Missing) | 405 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Loading_group
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 23 | |
|---|---|
| 11 | 3303 |
| 25 | 2814 |
| 13 | 1700 |
| 24 | 1186 |
| Other values (7) | 2858 |
| Value | Count | Frequency (%) | |
| 23 | 78836 | 86.9% | |
| 11 | 3303 | 3.6% | |
| 25 | 2814 | 3.1% | |
| 13 | 1700 | 1.9% | |
| 24 | 1186 | 1.3% | |
| 12 | 839 | 0.9% | |
| 22 | 748 | 0.8% | |
| 15 | 595 | 0.7% | |
| 14 | 333 | 0.4% | |
| 19 | 206 | 0.2% | |
| Other values (2) | 137 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.998544605 |
| Min length | 1 |
| Distinct count | 306 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 6891 |
| Missing (%) | 7.6% |
| Memory size | 708.6 KiB |
| 13 | 3180 |
|---|---|
| 12 | 3005 |
| 393 | 2471 |
| 0 | 2361 |
| 14 | 2016 |
| Other values (300) |
| Value | Count | Frequency (%) | |
| 13 | 3180 | 3.5% | |
| 12 | 3005 | 3.3% | |
| 393 | 2471 | 2.7% | |
| 0 | 2361 | 2.6% | |
| 14 | 2016 | 2.2% | |
| 60 | 1893 | 2.1% | |
| 392 | 1868 | 2.1% | |
| 432 | 1705 | 1.9% | |
| 420 | 1683 | 1.9% | |
| 54 | 1602 | 1.8% | |
| Other values (295) | 62022 | 68.4% | |
| (Missing) | 6891 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.558805694 |
| Min length | 1 |
Material_Type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| ZHW1 | |
|---|---|
| ZHW3 | 6697 |
| ZUB1 | 243 |
| Value | Count | Frequency (%) | |
| ZHW1 | 83757 | 92.3% | |
| ZHW3 | 6697 | 7.4% | |
| ZUB1 | 243 | 0.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 07/2018 | 3186 |
|---|---|
| 01/2019 | 3150 |
| 08/2018 | 3131 |
| 10/2018 | 3127 |
| 07/2019 | 3114 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3186 | 3.5% | |
| 01/2019 | 3150 | 3.5% | |
| 08/2018 | 3131 | 3.5% | |
| 10/2018 | 3127 | 3.4% | |
| 07/2019 | 3114 | 3.4% | |
| 01/2018 | 3107 | 3.4% | |
| 10/2017 | 3087 | 3.4% | |
| 05/2018 | 3086 | 3.4% | |
| 09/2019 | 3085 | 3.4% | |
| 03/2019 | 3082 | 3.4% | |
| Other values (20) | 59542 | 65.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
| Distinct count | 30 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 07/2018 | 3186 |
|---|---|
| 01/2019 | 3150 |
| 08/2018 | 3131 |
| 10/2018 | 3127 |
| 07/2019 | 3114 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 07/2018 | 3186 | 3.5% | |
| 01/2019 | 3150 | 3.5% | |
| 08/2018 | 3131 | 3.5% | |
| 10/2018 | 3127 | 3.4% | |
| 07/2019 | 3114 | 3.4% | |
| 01/2018 | 3107 | 3.4% | |
| 10/2017 | 3087 | 3.4% | |
| 05/2018 | 3086 | 3.4% | |
| 09/2019 | 3085 | 3.4% | |
| 03/2019 | 3082 | 3.4% | |
| Other values (20) | 59542 | 65.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
Must_prescribe
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 56 |
| Missing (%) | 0.1% |
| Memory size | 708.6 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 56 |
| Value | Count | Frequency (%) | |
| 1 | 57411 | 63.3% | |
| 0 | 33230 | 36.6% | |
| (Missing) | 56 | 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 41313 |
| Missing (%) | 45.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1018751012 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5.0 |
| Zeros | 46358 |
| Zeros (%) | 51.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4602865691 |
|---|---|
| Coefficient of variation (CV) | 4.518145881 |
| Kurtosis | 39.7921035 |
| Mean | 0.1018751012 |
| Median Absolute Deviation (MAD) | 0.1912654278 |
| Skewness | 5.756198531 |
| Sum | 5031 |
| Variance | 0.2118637257 |
| Value | Count | Frequency (%) | |
| 0 | 46358 | 51.1% | |
| 1 | 1700 | 1.9% | |
| 2 | 839 | 0.9% | |
| 3 | 391 | 0.4% | |
| 5 | 96 | 0.1% | |
| (Missing) | 41313 | 45.6% |
| Value | Count | Frequency (%) | |
| 0 | 46358 | 51.1% | |
| 1 | 1700 | 1.9% | |
| 2 | 839 | 0.9% | |
| 3 | 391 | 0.4% | |
| 5 | 96 | 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 96 | 0.1% | |
| 3 | 391 | 0.4% | |
| 2 | 839 | 0.9% | |
| 1 | 1700 | 1.9% | |
| 0 | 46358 | 51.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 7350 |
|---|
| Value | Count | Frequency (%) | |
| 7350 | 90697 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 2163 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75058.45476 |
|---|---|
| Minimum | 0 |
| Maximum | 4302782 |
| Zeros | 8934 |
| Zeros (%) | 9.9% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 744 |
| median | 4390 |
| Q3 | 46088 |
| 95-th percentile | 364336 |
| Maximum | 4302782 |
| Range | 4302782 |
| Interquartile range (IQR) | 45344 |
Descriptive statistics
| Standard deviation | 233217.7711 |
|---|---|
| Coefficient of variation (CV) | 3.10714858 |
| Kurtosis | 109.8697089 |
| Mean | 75058.45476 |
| Median Absolute Deviation (MAD) | 103912.464 |
| Skewness | 8.449247232 |
| Sum | 6807576671 |
| Variance | 5.439052875e+10 |
| Value | Count | Frequency (%) | |
| 0 | 8934 | 9.9% | |
| 627 | 159 | 0.2% | |
| 465 | 141 | 0.2% | |
| 1466 | 139 | 0.2% | |
| 1294 | 137 | 0.2% | |
| 471 | 130 | 0.1% | |
| 598 | 125 | 0.1% | |
| 3785 | 120 | 0.1% | |
| 4855 | 120 | 0.1% | |
| 6903 | 120 | 0.1% | |
| Other values (2153) | 80572 | 88.8% |
| Value | Count | Frequency (%) | |
| 0 | 8934 | 9.9% | |
| 1 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4302782 | 60 | 0.1% | |
| 3093749 | 60 | 0.1% | |
| 2913005 | 60 | 0.1% | |
| 1601720 | 60 | 0.1% | |
| 1553512 | 60 | 0.1% |
| Distinct count | 1453 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.75922585 |
|---|---|
| Minimum | 0.01 |
| Maximum | 13106.76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.14 |
| Q1 | 0.48 |
| median | 4.8 |
| Q3 | 16.42 |
| 95-th percentile | 78.85 |
| Maximum | 13106.76 |
| Range | 13106.75 |
| Interquartile range (IQR) | 15.94 |
Descriptive statistics
| Standard deviation | 330.9380054 |
|---|---|
| Coefficient of variation (CV) | 8.119339818 |
| Kurtosis | 784.5144498 |
| Mean | 40.75922585 |
| Median Absolute Deviation (MAD) | 59.68374267 |
| Skewness | 24.55626018 |
| Sum | 3696576.47 |
| Variance | 109519.9634 |
| Value | Count | Frequency (%) | |
| 0.14 | 1143 | 1.3% | |
| 0.16 | 893 | 1.0% | |
| 0.15 | 881 | 1.0% | |
| 0.33 | 873 | 1.0% | |
| 0.2 | 862 | 1.0% | |
| 0.29 | 854 | 0.9% | |
| 0.11 | 846 | 0.9% | |
| 0.51 | 762 | 0.8% | |
| 11.7 | 733 | 0.8% | |
| 0.1 | 715 | 0.8% | |
| Other values (1442) | 82131 | 90.6% |
| Value | Count | Frequency (%) | |
| 0.01 | 173 | 0.2% | |
| 0.03 | 195 | 0.2% | |
| 0.04 | 151 | 0.2% | |
| 0.05 | 210 | 0.2% | |
| 0.06 | 177 | 0.2% |
| Value | Count | Frequency (%) | |
| 13106.76 | 1 | < 0.1% | |
| 12471.82 | 28 | < 0.1% | |
| 10466.91 | 4 | < 0.1% | |
| 9371.7 | 5 | < 0.1% | |
| 8226.27 | 2 | < 0.1% |
| Distinct count | 1879 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 308.4209645 |
|---|---|
| Minimum | 0.0 |
| Maximum | 49409.36 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.22 |
| Q1 | 7.6 |
| median | 16.38 |
| Q3 | 71.37 |
| 95-th percentile | 1532.16 |
| Maximum | 49409.36 |
| Range | 49409.36 |
| Interquartile range (IQR) | 63.77 |
Descriptive statistics
| Standard deviation | 1365.125041 |
|---|---|
| Coefficient of variation (CV) | 4.426174606 |
| Kurtosis | 197.0158618 |
| Mean | 308.4209645 |
| Median Absolute Deviation (MAD) | 474.9928068 |
| Skewness | 11.23716775 |
| Sum | 27971622.53 |
| Variance | 1863566.377 |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 4.8 | 1074 | 1.2% | |
| 4.2 | 922 | 1.0% | |
| 15.3 | 635 | 0.7% | |
| 3.3 | 611 | 0.7% | |
| 8.7 | 599 | 0.7% | |
| 6 | 583 | 0.6% | |
| 11.7 | 530 | 0.6% | |
| 5.7 | 481 | 0.5% | |
| 3 | 480 | 0.5% | |
| Other values (1868) | 83454 | 92.0% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 0.03 | 52 | 0.1% | |
| 0.07 | 60 | 0.1% | |
| 0.09 | 75 | 0.1% | |
| 0.1 | 179 | 0.2% |
| Value | Count | Frequency (%) | |
| 49409.36 | 4 | < 0.1% | |
| 41212.53 | 1 | < 0.1% | |
| 35099.96 | 5 | < 0.1% | |
| 30433.62 | 1 | < 0.1% | |
| 27037.8 | 7 | < 0.1% |
Pure_OTC
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 67205 | 74.1% | |
| 1 | 23492 | 25.9% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.13395151 |
|---|---|
| Minimum | 0.0 |
| Maximum | 448.0 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 90 |
| Maximum | 448 |
| Range | 448 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.59908774 |
|---|---|
| Coefficient of variation (CV) | 1.236238769 |
| Kurtosis | 18.16234971 |
| Mean | 23.13395151 |
| Median Absolute Deviation (MAD) | 20.06459564 |
| Skewness | 2.834172256 |
| Sum | 2098180 |
| Variance | 817.9078198 |
| Value | Count | Frequency (%) | |
| 1 | 32341 | 35.7% | |
| 30 | 20321 | 22.4% | |
| 28 | 6078 | 6.7% | |
| 60 | 4679 | 5.2% | |
| 20 | 4570 | 5.0% | |
| 100 | 3030 | 3.3% | |
| 10 | 2182 | 2.4% | |
| 50 | 2030 | 2.2% | |
| 5 | 1623 | 1.8% | |
| 56 | 1516 | 1.7% | |
| Other values (44) | 12327 | 13.6% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 1 | 32341 | 35.7% | |
| 2 | 1026 | 1.1% | |
| 3 | 663 | 0.7% | |
| 4 | 1165 | 1.3% |
| Value | Count | Frequency (%) | |
| 448 | 1 | < 0.1% | |
| 400 | 36 | < 0.1% | |
| 270 | 3 | < 0.1% | |
| 224 | 3 | < 0.1% | |
| 210 | 30 | < 0.1% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.13395151 |
|---|---|
| Minimum | 0 |
| Maximum | 448 |
| Zeros | 1324 |
| Zeros (%) | 1.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 90 |
| Maximum | 448 |
| Range | 448 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.59908774 |
|---|---|
| Coefficient of variation (CV) | 1.236238769 |
| Kurtosis | 18.16234971 |
| Mean | 23.13395151 |
| Median Absolute Deviation (MAD) | 20.06459564 |
| Skewness | 2.834172256 |
| Sum | 2098180 |
| Variance | 817.9078198 |
| Value | Count | Frequency (%) | |
| 1 | 32341 | 35.7% | |
| 30 | 20321 | 22.4% | |
| 28 | 6078 | 6.7% | |
| 60 | 4679 | 5.2% | |
| 20 | 4570 | 5.0% | |
| 100 | 3030 | 3.3% | |
| 10 | 2182 | 2.4% | |
| 50 | 2030 | 2.2% | |
| 5 | 1623 | 1.8% | |
| 56 | 1516 | 1.7% | |
| Other values (44) | 12327 | 13.6% |
| Value | Count | Frequency (%) | |
| 0 | 1324 | 1.5% | |
| 1 | 32341 | 35.7% | |
| 2 | 1026 | 1.1% | |
| 3 | 663 | 0.7% | |
| 4 | 1165 | 1.3% |
| Value | Count | Frequency (%) | |
| 448 | 1 | < 0.1% | |
| 400 | 36 | < 0.1% | |
| 270 | 3 | < 0.1% | |
| 224 | 3 | < 0.1% | |
| 210 | 30 | < 0.1% |
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.70324267 |
|---|---|
| Minimum | 0 |
| Maximum | 1000 |
| Zeros | 64712 |
| Zeros (%) | 71.3% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5 |
| 95-th percentile | 120 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 82.22988555 |
|---|---|
| Coefficient of variation (CV) | 3.328708164 |
| Kurtosis | 42.04184641 |
| Mean | 24.70324267 |
| Median Absolute Deviation (MAD) | 39.00106848 |
| Skewness | 5.690316125 |
| Sum | 2240510 |
| Variance | 6761.754077 |
| Value | Count | Frequency (%) | |
| 0 | 64712 | 71.3% | |
| 15 | 3022 | 3.3% | |
| 100 | 2390 | 2.6% | |
| 10 | 2085 | 2.3% | |
| 50 | 1960 | 2.2% | |
| 30 | 1905 | 2.1% | |
| 5 | 1510 | 1.7% | |
| 20 | 1174 | 1.3% | |
| 3 | 1057 | 1.2% | |
| 500 | 992 | 1.1% | |
| Other values (55) | 9890 | 10.9% |
| Value | Count | Frequency (%) | |
| 0 | 64712 | 71.3% | |
| 1 | 863 | 1.0% | |
| 2 | 803 | 0.9% | |
| 3 | 1057 | 1.2% | |
| 4 | 145 | 0.2% |
| Value | Count | Frequency (%) | |
| 1000 | 115 | 0.1% | |
| 750 | 58 | 0.1% | |
| 500 | 992 | 1.1% | |
| 454 | 51 | 0.1% | |
| 450 | 121 | 0.1% |
| Distinct count | 2132 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72403.71368 |
|---|---|
| Minimum | 0 |
| Maximum | 5242283 |
| Zeros | 9502 |
| Zeros (%) | 10.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 691 |
| median | 3116 |
| Q3 | 40883 |
| 95-th percentile | 295952 |
| Maximum | 5242283 |
| Range | 5242283 |
| Interquartile range (IQR) | 40192 |
Descriptive statistics
| Standard deviation | 288122.2307 |
|---|---|
| Coefficient of variation (CV) | 3.979384704 |
| Kurtosis | 149.4994849 |
| Mean | 72403.71368 |
| Median Absolute Deviation (MAD) | 103665.7207 |
| Skewness | 10.41643199 |
| Sum | 6566799620 |
| Variance | 8.301441984e+10 |
| Value | Count | Frequency (%) | |
| 0 | 9502 | 10.5% | |
| 1235 | 136 | 0.1% | |
| 1392 | 130 | 0.1% | |
| 461 | 126 | 0.1% | |
| 736 | 122 | 0.1% | |
| 1796 | 121 | 0.1% | |
| 1635 | 120 | 0.1% | |
| 49325 | 120 | 0.1% | |
| 594 | 119 | 0.1% | |
| 82098 | 119 | 0.1% | |
| Other values (2122) | 80082 | 88.3% |
| Value | Count | Frequency (%) | |
| 0 | 9502 | 10.5% | |
| 1 | 19 | < 0.1% | |
| 3 | 33 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 21 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5242283 | 60 | 0.1% | |
| 5095219 | 60 | 0.1% | |
| 3274632 | 60 | 0.1% | |
| 2616084 | 60 | 0.1% | |
| 2266471 | 60 | 0.1% |
Seasonality
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 708.6 KiB |
| no | |
|---|---|
| yes | 14012 |
| (Missing) | 11 |
| Value | Count | Frequency (%) | |
| no | 76674 | 84.5% | |
| yes | 14012 | 15.4% | |
| (Missing) | 11 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90697 | 100.0% |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 7904 |
| Missing (%) | 8.7% |
| Memory size | 708.6 KiB |
| TAB | |
|---|---|
| CAP | |
| CR | 4923 |
| COL | 3135 |
| CPL | 2565 |
| Other values (47) |
| Value | Count | Frequency (%) | |
| TAB | 37094 | 40.9% | |
| CAP | 8375 | 9.2% | |
| CR | 4923 | 5.4% | |
| COL | 3135 | 3.5% | |
| CPL | 2565 | 2.8% | |
| GEL | 2051 | 2.3% | |
| OIN | 1977 | 2.2% | |
| SOL | 1789 | 2.0% | |
| INJ | 1639 | 1.8% | |
| LIQ | 1592 | 1.8% | |
| Other values (42) | 17653 | 19.5% | |
| (Missing) | 7904 | 8.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.03286768 |
| Min length | 2 |
| Distinct count | 3207 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 10000005695 | 60 |
|---|---|
| 10000003201 | 60 |
| 10000005712 | 60 |
| 10000005869 | 60 |
| 10000006644 | 60 |
| Other values (3202) |
| Value | Count | Frequency (%) | |
| 10000005695 | 60 | 0.1% | |
| 10000003201 | 60 | 0.1% | |
| 10000005712 | 60 | 0.1% | |
| 10000005869 | 60 | 0.1% | |
| 10000006644 | 60 | 0.1% | |
| 10000005390 | 60 | 0.1% | |
| 10000006022 | 60 | 0.1% | |
| 10000005088 | 60 | 0.1% | |
| 10000005346 | 60 | 0.1% | |
| 10000005221 | 60 | 0.1% | |
| Other values (3197) | 90097 | 99.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 11 |
|---|---|
| Mean length | 11 |
| Min length | 11 |
Sourcing_source
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| ארץ | |
|---|---|
| חו"ל | 554 |
| Value | Count | Frequency (%) | |
| ארץ | 90143 | 99.4% | |
| חו"ל | 554 | 0.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.006108251 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 90697 | 100.0% |
storecode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| 3224 | |
|---|---|
| 3315 |
| Value | Count | Frequency (%) | |
| 3224 | 46054 | 50.8% | |
| 3315 | 44643 | 49.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7362 |
| Missing (%) | 8.1% |
| Memory size | 708.6 KiB |
| 0 | |
|---|---|
| 1 | 333 |
| 3 | 55 |
| 2 | 15 |
| Value | Count | Frequency (%) | |
| 0 | 82932 | 91.4% | |
| 1 | 333 | 0.4% | |
| 3 | 55 | 0.1% | |
| 2 | 15 | < 0.1% | |
| (Missing) | 7362 | 8.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
TranQuantity
Real number (ℝ≥0)
| Distinct count | 1943 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196.9286195 |
|---|---|
| Minimum | 0 |
| Maximum | 12780 |
| Zeros | 447 |
| Zeros (%) | 0.5% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 20 |
| Q3 | 129 |
| 95-th percentile | 955.2 |
| Maximum | 12780 |
| Range | 12780 |
| Interquartile range (IQR) | 126 |
Descriptive statistics
| Standard deviation | 591.2900672 |
|---|---|
| Coefficient of variation (CV) | 3.002560363 |
| Kurtosis | 91.31557023 |
| Mean | 196.9286195 |
| Median Absolute Deviation (MAD) | 262.7721293 |
| Skewness | 7.8744681 |
| Sum | 17860835 |
| Variance | 349623.9436 |
| Value | Count | Frequency (%) | |
| 1 | 10802 | 11.9% | |
| 2 | 7535 | 8.3% | |
| 3 | 5312 | 5.9% | |
| 4 | 4111 | 4.5% | |
| 60 | 3589 | 4.0% | |
| 30 | 3294 | 3.6% | |
| 5 | 2936 | 3.2% | |
| 6 | 2478 | 2.7% | |
| 120 | 2067 | 2.3% | |
| 90 | 1843 | 2.0% | |
| Other values (1933) | 46730 | 51.5% |
| Value | Count | Frequency (%) | |
| 0 | 447 | 0.5% | |
| 1 | 10802 | 11.9% | |
| 2 | 7535 | 8.3% | |
| 3 | 5312 | 5.9% | |
| 4 | 4111 | 4.5% |
| Value | Count | Frequency (%) | |
| 12780 | 2 | < 0.1% | |
| 12420 | 1 | < 0.1% | |
| 12240 | 1 | < 0.1% | |
| 11460 | 2 | < 0.1% | |
| 11264 | 1 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 85285 |
| Missing (%) | 94.0% |
| Memory size | 708.6 KiB |
| BOX | |
|---|---|
| TUB | |
| BOT | |
| PKG | 200 |
| BAG | 24 |
| Value | Count | Frequency (%) | |
| BOX | 3632 | 4.0% | |
| TUB | 773 | 0.9% | |
| BOT | 770 | 0.8% | |
| PKG | 200 | 0.2% | |
| BAG | 24 | < 0.1% | |
| KIT | 13 | < 0.1% | |
| (Missing) | 85285 | 94.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.940328787 |
| Min length | 3 |
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 89166 |
| Missing (%) | 98.3% |
| Memory size | 708.6 KiB |
| 01.03.2016 | 132 |
|---|---|
| 01.02.2018 | 117 |
| 01.10.2020 | 113 |
| 01.07.2018 | 107 |
| 01.10.2018 | 96 |
| Other values (27) |
| Value | Count | Frequency (%) | |
| 01.03.2016 | 132 | 0.1% | |
| 01.02.2018 | 117 | 0.1% | |
| 01.10.2020 | 113 | 0.1% | |
| 01.07.2018 | 107 | 0.1% | |
| 01.10.2018 | 96 | 0.1% | |
| 01.05.2020 | 86 | 0.1% | |
| 01.03.2017 | 81 | 0.1% | |
| 01.12.2019 | 71 | 0.1% | |
| 01.03.2020 | 66 | 0.1% | |
| 01.06.2018 | 65 | 0.1% | |
| Other values (22) | 597 | 0.7% | |
| (Missing) | 89166 | 98.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.101282292 |
| Min length | 4 |
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 86155 |
| Missing (%) | 95.0% |
| Memory size | 708.6 KiB |
| 28.02.2015 | 250 |
|---|---|
| 30.04.2015 | 247 |
| 30.11.2012 | 244 |
| 30.11.2013 | 181 |
| 31.01.2007 | 180 |
| Other values (77) |
| Value | Count | Frequency (%) | |
| 28.02.2015 | 250 | 0.3% | |
| 30.04.2015 | 247 | 0.3% | |
| 30.11.2012 | 244 | 0.3% | |
| 30.11.2013 | 181 | 0.2% | |
| 31.01.2007 | 180 | 0.2% | |
| 30.09.2012 | 142 | 0.2% | |
| 31.10.2013 | 120 | 0.1% | |
| 31.03.2015 | 119 | 0.1% | |
| 31.01.2008 | 113 | 0.1% | |
| 31.05.2014 | 113 | 0.1% | |
| Other values (72) | 2833 | 3.1% | |
| (Missing) | 86155 | 95.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.300473004 |
| Min length | 4 |
| Distinct count | 155 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 594 |
| Missing (%) | 0.7% |
| Memory size | 708.6 KiB |
| 400059 | 8701 |
|---|---|
| 400057 | 4983 |
| 408668 | 4824 |
| 400095 | 4199 |
| 400045 | 3597 |
| Other values (149) |
| Value | Count | Frequency (%) | |
| 400059 | 8701 | 9.6% | |
| 400057 | 4983 | 5.5% | |
| 408668 | 4824 | 5.3% | |
| 400095 | 4199 | 4.6% | |
| 400045 | 3597 | 4.0% | |
| 406885 | 3543 | 3.9% | |
| 407214 | 2828 | 3.1% | |
| 400026 | 2778 | 3.1% | |
| 410232 | 2705 | 3.0% | |
| 400032 | 2203 | 2.4% | |
| Other values (144) | 49742 | 54.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.986901441 |
| Min length | 4 |
volume
Real number (ℝ≥0)
| Distinct count | 739 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 195.6533072 |
|---|---|
| Minimum | 0 |
| Maximum | 9973 |
| Zeros | 127 |
| Zeros (%) | 0.1% |
| Memory size | 708.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 82 |
| Q3 | 244 |
| 95-th percentile | 741 |
| Maximum | 9973 |
| Range | 9973 |
| Interquartile range (IQR) | 238 |
Descriptive statistics
| Standard deviation | 368.7031077 |
|---|---|
| Coefficient of variation (CV) | 1.884471635 |
| Kurtosis | 73.50751411 |
| Mean | 195.6533072 |
| Median Absolute Deviation (MAD) | 205.7398271 |
| Skewness | 6.197226803 |
| Sum | 17745168 |
| Variance | 135941.9817 |
| Value | Count | Frequency (%) | |
| 3 | 7230 | 8.0% | |
| 4 | 5559 | 6.1% | |
| 5 | 4581 | 5.1% | |
| 6 | 4036 | 4.4% | |
| 7 | 3087 | 3.4% | |
| 2 | 3075 | 3.4% | |
| 9 | 2316 | 2.6% | |
| 8 | 2144 | 2.4% | |
| 10 | 1329 | 1.5% | |
| 11 | 1087 | 1.2% | |
| Other values (729) | 56253 | 62.0% |
| Value | Count | Frequency (%) | |
| 0 | 127 | 0.1% | |
| 1 | 947 | 1.0% | |
| 2 | 3075 | 3.4% | |
| 3 | 7230 | 8.0% | |
| 4 | 5559 | 6.1% |
| Value | Count | Frequency (%) | |
| 9973 | 2 | < 0.1% | |
| 8258 | 11 | < 0.1% | |
| 4554 | 60 | 0.1% | |
| 4377 | 17 | < 0.1% | |
| 4326 | 54 | 0.1% |
Volume_marker
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 708.6 KiB |
| LOW | |
|---|---|
| HIGH |
| Value | Count | Frequency (%) | |
| LOW | 57339 | 63.2% | |
| HIGH | 33358 | 36.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.367796068 |
| Min length | 3 |
First rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | df_index | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20140 | B | 15 | 1180 | ATC:G03AA09 | PAC | B | 1.0 | 0.0 | ave | 6369 | 83062.0 | 8491 | None | None | 01.04.2005 | Oral contraceptive | Oral Contra. | 0 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 8811 | 1 | 1.0 | 0.0 | 23 | 171 | ZHW1 | 03/2017 | 03/2017 | 1.0 | 0.0 | 7350.0 | 7351 | 9.36 | 196.56 | 0.0 | 21.0 | 21 | 0 | 4671 | no | 1.0 | TAB | 10000005719 | ארץ | 1.0 | 3224.0 | 0.0 | 11 | BOX | None | None | 408668 | 101 | LOW |
| 1 | 20190 | C | 20 | 1054 | ATC:N06AA04 | EA | B | 1.0 | 1.0 | ave | 26450 | 306420.0 | 34920 | None | None | 01.01.1995 | Depression-Tricyclic | Antidepressants | 1 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999005422 | 68550 | 2 | 1.0 | 0.0 | 23 | 420 | ZHW1 | 02/2019 | 02/2019 | 1.0 | 0.0 | 7350.0 | 25312 | 0.21 | 6.30 | 0.0 | 30.0 | 30 | 0 | 31010 | no | 1.0 | TAB | 10000006427 | ארץ | 1.0 | 3224.0 | 0.0 | 120 | None | None | None | 400095 | 3 | LOW |
| 2 | 20270 | C | 24 | 1351 | ATC:D08AX08 | EA | E | 1.0 | 0.0 | ave | 1321 | 13544.0 | 2220 | 0 | 0 | None | חיטוי ידיים | cosmetics | 2 | 2016-05-18 | None | 0.0 | None | None | 0.0 | 0.0 | None | 875 | 0 | 0.0 | 0.0 | 23 | 392 | ZHW1 | 07/2017 | 07/2017 | 0.0 | NaN | 7350.0 | 1231 | 14.04 | 14.04 | 1.0 | 1.0 | 1 | 500 | 924 | no | 1.0 | GEL | 10000001880 | ארץ | 1.0 | 3315.0 | 0.0 | 2 | None | None | None | 124207 | 941 | HIGH |
| 3 | 20180 | C | 19 | 1156 | ATC:M01AH01 | EA | B | 1.0 | 0.0 | ave | 47073 | 525410.0 | 59330 | None | None | None | NSAIDS-COX 2 inhibtors | Rheum. Arth. | 4 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999010655 | 87390 | 1 | 0.0 | 0.0 | 23 | 65 | ZHW1 | 02/2017 | 02/2017 | 1.0 | 0.0 | 7350.0 | 45373 | 0.56 | 5.60 | 0.0 | 10.0 | 10 | 0 | 53858 | no | 1.0 | CAP | 10000006732 | ארץ | 1.0 | 3224.0 | 0.0 | 30 | None | None | None | 400077 | 10 | LOW |
| 4 | 20120 | B | 13 | 1605 | ATC:C08CA01 | EA | B | 1.0 | 1.0 | ave | 0 | 0.0 | 0 | None | None | 01.01.2000 | Calcium Chanell Blockers | Calcium Chanell Blockers | 5 | 2006-09-26 | None | 0.0 | None | None | 0.0 | 0.0 | 3999019172 | 0 | 0 | 1.0 | 0.0 | 23 | 431 | ZHW1 | 04/2017 | 04/2017 | 1.0 | 0.0 | 7350.0 | 0 | 0.14 | 2.80 | 0.0 | 20.0 | 20 | 0 | 0 | no | 1.0 | TAB | 10000004522 | ארץ | 1.0 | 3315.0 | 0.0 | 3220 | None | None | None | 400059 | 6 | HIGH |
| 5 | 10150 | C | 72 | None | ZRP:102UB01 | EA | D | NaN | 1.0 | ave | 0 | 0.0 | 0 | None | None | 01.03.2001 | None | None | 6 | 2009-06-03 | None | 0.0 | None | None | 0.0 | 0.0 | None | 0 | 0 | 1.0 | 0.0 | 23 | None | ZHW3 | 03/2019 | 03/2019 | 1.0 | NaN | 7350.0 | 0 | 32.83 | 0.00 | 0.0 | 0.0 | 0 | 0 | 0 | no | 1.0 | None | 10000003897 | ארץ | 1.0 | 3315.0 | NaN | 4 | None | None | None | 400044 | 548 | HIGH |
| 6 | 20220 | C | 22 | 1946 | ATC:S01XA30 | PAC | E | 1.0 | 0.0 | ave | 1429 | 17751.0 | 1852 | None | None | None | טיפות ליובש בעיניים | Artificial Tears | 7 | 2010-12-27 | None | 0.0 | None | None | 0.0 | 0.0 | None | 2952 | 2 | 0.0 | 0.0 | 23 | 128 | ZHW1 | 05/2018 | 05/2018 | 0.0 | NaN | 7350.0 | 1490 | 25.74 | 823.68 | 1.0 | 32.0 | 32 | 0 | 1544 | no | 1.0 | COL | 10000003478 | ארץ | 1.0 | 3315.0 | 0.0 | 10 | None | None | None | 400006 | 505 | LOW |
| 7 | 20100 | B | 11 | 1354 | ATC:A01AB09 | EA | B | 1.0 | 0.0 | ave | 3480 | 39454.0 | 4049 | None | None | 01.01.1995 | טיפול אנטי פטרייתי | Fungal Inf, Oroph. | 8 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 2510 | 0 | 1.0 | 0.0 | 23 | 83 | ZHW1 | 01/2018 | 01/2018 | 0.0 | 0.0 | 7350.0 | 3255 | 13.06 | 13.06 | 0.0 | 1.0 | 1 | 40 | 1740 | no | 1.0 | GEL | 10000006295 | ארץ | 1.0 | 3315.0 | 0.0 | 4 | None | None | 30.04.2012 | 117469 | 214 | LOW |
| 8 | 10100 | C | 24 | 1429 | ZRP:A21AD | EA | E | NaN | 0.0 | ave | 514 | 5821.0 | 712 | None | None | None | סד תמיכה ליד | None | 9 | 2006-03-06 | None | 0.0 | None | None | 0.0 | 0.0 | None | 1282 | 2 | 0.0 | 0.0 | 23 | None | ZHW3 | 05/2018 | 05/2018 | 0.0 | NaN | 7350.0 | 482 | 29.25 | 29.25 | 1.0 | 1.0 | 1 | 0 | 607 | no | 1.0 | None | 10000006992 | ארץ | 1.0 | 3224.0 | NaN | 2 | None | None | None | 400123 | 773 | LOW |
| 9 | 20190 | C | 20 | 1017 | ATC:N07CA02 | EA | B | 1.0 | 1.0 | ave | 182942 | 2158850.0 | 223275 | None | None | 01.01.1995 | Antivertigo preparations | Meniere's Dis. | 11 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 279325 | 1 | 1.0 | 0.0 | 23 | 209 | ZHW1 | 06/2017 | 06/2017 | 1.0 | 0.0 | 7350.0 | 177417 | 0.20 | 5.00 | 0.0 | 25.0 | 25 | 0 | 128059 | no | 1.0 | TAB | 10000006644 | ארץ | 1.0 | 3224.0 | 0.0 | 575 | None | None | 30.09.2012 | 401974 | 7 | HIGH |
Last rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | df_index | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | General_purpose_ | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | month_year_ | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90687 | 20130 | C | 14 | 1517 | ATC:D08AX01 | EA | B | 1.0 | NaN | ave | 2514 | 28150.0 | 3399 | None | None | 01.01.1995 | תכשיר לחיטוי | Antiseptic | 109189 | 2014-08-24 | None | 0.0 | None | None | 0.0 | 0.0 | None | 3409 | 1 | 1.0 | 0.0 | 23 | 135 | ZHW1 | 02/2017 | 02/2017 | NaN | NaN | 7350.0 | 2414 | 3.28 | 3.28 | 0.0 | 1.0 | 1 | 100 | 1760 | no | 1.0 | SOL | 10000002477 | ארץ | 1.0 | 3315.0 | 0.0 | 2 | None | None | None | 400171 | 362 | HIGH |
| 90688 | 20130 | C | 14 | 1519 | ATC:D02AC02 | EA | E | 1.0 | 0.0 | pred | 900 | 9426.0 | 1085 | None | None | None | תכשיר רחצה טיפולי - תינוקות | Dry Skin | 109190 | 2010-06-09 | None | 0.0 | None | None | 0.0 | 0.0 | None | 1563 | 1 | 0.0 | 0.0 | 25 | 142 | ZHW1 | 06/2018 | 06/2018 | 0.0 | NaN | 7350.0 | 951 | 30.14 | 30.14 | 1.0 | 1.0 | 1 | 500 | 760 | yes | 1.0 | OIL | 10000003622 | ארץ | 1.0 | 3315.0 | 0.0 | 2 | None | None | None | 400044 | 985 | HIGH |
| 90689 | 20160 | A | 17 | 1651 | ATC:J07AJ52 | EA | B | 2.0 | 0.0 | pred | 0 | 0.0 | 0 | None | None | None | DPT Vac. | DPT Vac. | 109191 | 2011-03-22 | None | 1.0 | None | None | 0.0 | 0.0 | 3999002140 | 0 | 0 | 1.0 | 0.0 | 11 | 96 | ZHW1 | 01/2017 | 01/2017 | 1.0 | NaN | 7350.0 | 0 | 63.18 | 63.18 | 0.0 | 1.0 | 1 | 0 | 0 | no | 1.0 | SRG | 10000003406 | ארץ | 1.0 | 3315.0 | 0.0 | 0 | None | None | None | 400164 | 159 | LOW |
| 90690 | 20240 | B | 24 | 1401 | ATC:V06DB15 | EA | B | 1.0 | 0.0 | ave | 15000 | 196110.0 | 19770 | None | None | 01.03.2008 | מזון ייעודי | Metab. Disord. | 109192 | 2014-11-04 | None | 0.0 | None | None | 0.0 | 0.0 | None | 10860 | 0 | 1.0 | 0.0 | 25 | 107 | ZHW1 | 04/2019 | 04/2019 | 0.0 | NaN | 7350.0 | 16335 | 9.01 | 9.01 | 1.0 | 1.0 | 1 | 220 | 8916 | no | 1.0 | LIQ | 10000002408 | ארץ | 1.0 | 3315.0 | 0.0 | 60 | None | None | None | 401882 | 465 | HIGH |
| 90691 | 20180 | B | 19 | 1076 | ATC:M04AC01 | EA | B | 1.0 | 1.0 | ave | 463260 | 5311080.0 | 619170 | None | None | 01.01.1995 | FMF | Gout | 109193 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 338070 | 0 | 1.0 | 0.0 | 23 | 75 | ZHW1 | 01/2017 | 01/2017 | 1.0 | 5.0 | 7350.0 | 451081 | 0.35 | 10.50 | 0.0 | 30.0 | 30 | 0 | 231630 | no | 1.0 | TAB | 10000006474 | ארץ | 1.0 | 3224.0 | 0.0 | 1300 | None | None | None | 400045 | 2 | HIGH |
| 90692 | 20190 | C | 20 | 1823 | ATC:N02AA05 | EA | B | 1.0 | 0.0 | ave | 693 | 8445.0 | 861 | None | None | None | Pain, Mod/Sev | Pain, Mod/Sev | 109195 | 2013-10-14 | None | 0.0 | None | None | 0.0 | 0.0 | None | 812 | 1 | 0.0 | 0.0 | 13 | 59 | ZHW1 | 03/2018 | 03/2018 | 1.0 | 1.0 | 7350.0 | 731 | 32.76 | 32.76 | 0.0 | 1.0 | 1 | 30 | 778 | no | 1.0 | SYR | 10000002704 | ארץ | 1.0 | 3315.0 | 0.0 | 4 | None | None | None | 400045 | 168 | LOW |
| 90693 | 20130 | C | 14 | 1352 | ATC:D08AG02 | EA | B | 1.0 | 0.0 | pred | 6112 | 74934.0 | 6830 | None | None | 01.01.1995 | חיטוי נגעים בעור | Antiseptic | 109196 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999021150 | 5258 | 0 | 1.0 | 0.0 | 23 | 135 | ZHW1 | 03/2018 | 03/2018 | 0.0 | 0.0 | 7350.0 | 4924 | 3.51 | 3.51 | 0.0 | 1.0 | 1 | 15 | 3447 | yes | 1.0 | OIN | 10000006784 | ארץ | 1.0 | 3315.0 | 0.0 | 19 | None | None | None | 400057 | 138 | HIGH |
| 90694 | 20100 | C | 11 | 1375 | ATC:A07BB01 | EA | B | 1.0 | 0.0 | ave | 69973 | 637500.0 | 116040 | None | None | 01.01.1995 | טיפול בשלשול וכאב בטן | Diarrhea | 109197 | 2013-07-01 | None | 0.0 | None | None | 0.0 | 0.0 | 3999002540 | 99960 | 1 | 1.0 | 0.0 | 23 | 47 | ZHW1 | 06/2019 | 06/2019 | 0.0 | NaN | 7350.0 | 53466 | 0.29 | 5.80 | 0.0 | 20.0 | 20 | 0 | 81947 | no | 1.0 | TAB | 10000002793 | ארץ | 1.0 | 3315.0 | 0.0 | 240 | None | None | None | 400026 | 6 | LOW |
| 90695 | 20150 | C | 16 | 1694 | ATC:H02AB07 | EA | B | 1.0 | 1.0 | ave | 169400 | 1913000.0 | 221300 | None | None | 01.01.1995 | Glucocorticoid | Glucocorticoid | 109198 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | None | 202900 | 1 | 1.0 | 0.0 | 23 | 141 | ZHW1 | 09/2017 | 09/2017 | 1.0 | 0.0 | 7350.0 | 162085 | 0.15 | 15.00 | 0.0 | 100.0 | 100 | 0 | 180690 | no | 1.0 | TAB | 10000006612 | ארץ | 1.0 | 3224.0 | 0.0 | 300 | None | None | None | 400057 | 0 | LOW |
| 90696 | 20220 | B | 22 | 1082 | ATC:S01EA05 | EA | A | 1.0 | 1.0 | ave | 9242 | 108414.0 | 12071 | None | None | 01.10.2005 | Glaucoma alpha 2 agonist | Glaucoma | 109199 | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 0.0 | 3999001444 | 6359 | 0 | 1.0 | 0.0 | 23 | 15 | ZHW1 | 09/2019 | 09/2019 | 1.0 | 0.0 | 7350.0 | 8783 | 16.38 | 16.38 | 0.0 | 1.0 | 1 | 5 | 4621 | no | 1.0 | COL | 10000005869 | ארץ | 1.0 | 3315.0 | 0.0 | 40 | None | None | None | 400036 | 82 | LOW |